OYPNIV2

"192.168.0.1:sipop"

OYPNIV2

Descriptions

There is no desription for table OYPNIV2

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		ID_OYP_NIV2		VARCHAR (2)
		NOMBRE_OYP_NIV2		VARCHAR (30)
		DESCRIPCION_OYP_NIV2		VARCHAR (30)
		OYP_NIV1		VARCHAR (8)

Triggers

There are no triggers for table OYPNIV2

Indices

There are no indices for table OYPNIV2

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
OYPNIV1	INTEG_271	OYP_NIV1	ID_OYP_NIV1	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table OYPNIV2

Definition


CREATE TABLE OYPNIV2 (
    ID_OYP_NIV2 VARCHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE_OYP_NIV2 VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
    DESCRIPCION_OYP_NIV2 VARCHAR (30) CHARACTER SET NONE COLLATE NONE,
    OYP_NIV1 VARCHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE OYPNIV2 ADD PRIMARY KEY (ID_OYP_NIV2);
ALTER TABLE OYPNIV2 ADD  FOREIGN KEY (OYP_NIV1) REFERENCES OYPNIV1 (ID_OYP_NIV1);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 02:19 p.m.